/*
 Navicat Premium Data Transfer

 Source Server         : qdm107081471.my3w.com
 Source Server Type    : MySQL
 Source Server Version : 50148
 Source Host           : qdm107081471.my3w.com
 Source Database       : qdm107081471_db

 Target Server Type    : MySQL
 Target Server Version : 50148
 File Encoding         : utf-8

 Date: 07/03/2018 11:55:50 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `td_comment`
-- ----------------------------
DROP TABLE IF EXISTS `td_comment`;
CREATE TABLE `td_comment` (
  `comment_id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) DEFAULT NULL,
  `comment_text` varchar(255) DEFAULT NULL,
  `comment_date` datetime DEFAULT NULL,
  `comment_username` varchar(255) DEFAULT NULL,
  `comment_author` varchar(255) DEFAULT NULL,
  `comment_photo` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`comment_id`)
) ENGINE=MyISAM AUTO_INCREMENT=73 DEFAULT CHARSET=gbk;

-- ----------------------------
--  Records of `td_comment`
-- ----------------------------
BEGIN;
INSERT INTO `td_comment` VALUES ('72', '32', 'vfs mqa', '2017-02-08 16:12:33', '12345678', '', 'http://ogrv04tc4.bkt.clouddn.com/2016-11-17_582d48713a980.jpg'), ('71', '32', 'fgjhd', '2017-02-08 16:12:28', '12345678', '', 'http://ogrv04tc4.bkt.clouddn.com/2016-11-17_582d48713a980.jpg'), ('70', '30', '不会的呢', '2017-02-07 09:53:05', '123456', '123456', 'http://ogrv04tc4.bkt.clouddn.com/2016-11-17_582d48713a980.jpg'), ('69', '30', '是啊', '2017-02-07 09:52:50', '123456', '', 'http://ogrv04tc4.bkt.clouddn.com/2016-11-17_582d48713a980.jpg');
COMMIT;

-- ----------------------------
--  Table structure for `td_comment_good`
-- ----------------------------
DROP TABLE IF EXISTS `td_comment_good`;
CREATE TABLE `td_comment_good` (
  `comment_good_id` int(255) NOT NULL AUTO_INCREMENT,
  `comment_id` int(255) DEFAULT NULL,
  `uid` int(11) DEFAULT NULL,
  PRIMARY KEY (`comment_good_id`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=gbk;

-- ----------------------------
--  Records of `td_comment_good`
-- ----------------------------
BEGIN;
INSERT INTO `td_comment_good` VALUES ('38', '0', '24');
COMMIT;

-- ----------------------------
--  Table structure for `td_good`
-- ----------------------------
DROP TABLE IF EXISTS `td_good`;
CREATE TABLE `td_good` (
  `good_id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) DEFAULT NULL,
  `uid` int(11) DEFAULT NULL,
  PRIMARY KEY (`good_id`),
  KEY `good` (`post_id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=gbk;

-- ----------------------------
--  Records of `td_good`
-- ----------------------------
BEGIN;
INSERT INTO `td_good` VALUES ('31', '29', '23'), ('35', '30', '23');
COMMIT;

-- ----------------------------
--  Table structure for `td_post`
-- ----------------------------
DROP TABLE IF EXISTS `td_post`;
CREATE TABLE `td_post` (
  `post_id` int(11) NOT NULL AUTO_INCREMENT,
  `post_title` varchar(255) DEFAULT NULL,
  `post_admin` varchar(255) DEFAULT NULL,
  `post_content` varchar(255) DEFAULT NULL,
  `post_text` varchar(255) DEFAULT NULL,
  `post_type` varchar(255) DEFAULT NULL,
  `post_updatetime` datetime DEFAULT NULL,
  `post_createtime` datetime DEFAULT NULL,
  `post_image` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`post_id`),
  KEY `post_type` (`post_type`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=gbk;

-- ----------------------------
--  Records of `td_post`
-- ----------------------------
BEGIN;
INSERT INTO `td_post` VALUES ('29', '从你的全世界路过', '12345', '&lt;p&gt;&lt;span style=&quot;font-family: Verdana, Geneva, sans-serif; font-size: 15px; background-color: rgb(255, 255, 255);&quot;&gt;我希望有个如你一般的人。 如这山间清晨一般明亮清爽的人， 如奔赴古城道路上阳光一般的人， 温暖而不炙热，覆盖我所有肌肤。 由起点到夜晚，由山野到书房， 一切问题的答案都很简单。 我希望有个如你一般的人，贯彻未来，数遍生命的公路牌。&lt;', '我希望有个如你一般的人。 如这山间清晨一般明亮清爽的人， 如奔赴古城道路上阳光一般的人， 温暖而不炙热，覆盖我所有肌肤。 由起点到夜晚，由山野到书房， 一切问题的答案都很简单。 我希望有个如你一般的人，贯彻未来，数遍生命的公路牌。', '诗文', null, '2017-02-04 14:43:10', ''), ('33', '风一般的人生', '不具名浪漫', '&lt;p&gt;&lt;img src=\\&quot;http://ofld5g7th.bkt.clouddn.com/Public%2Fupload%2F2017-07-10%2F14996485564.jpg\\&quot; title=\\&quot;Public/upload/2017-07-10/14996485564.jpg\\&quot; alt=\\&quot;360wallpaper_dt.jpg\\&quot;/&gt;风起于青萍之末,舞于松柏之下,止于草莽之间。&lt;/p&gt;', '风起于青萍之末,舞于松柏之下,止于草莽之间。', '诗文', null, '2017-07-10 09:02:40', 'http://ofld5g7th.bkt.clouddn.com/Public%2Fupload%2F2017-07-10%2F14996485564.jpg');
COMMIT;

-- ----------------------------
--  Table structure for `td_post_type`
-- ----------------------------
DROP TABLE IF EXISTS `td_post_type`;
CREATE TABLE `td_post_type` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=gbk;

-- ----------------------------
--  Records of `td_post_type`
-- ----------------------------
BEGIN;
INSERT INTO `td_post_type` VALUES ('1', '心情'), ('2', '诗文'), ('3', '相册'), ('4', '视频'), ('5', '技能');
COMMIT;

-- ----------------------------
--  Table structure for `td_user`
-- ----------------------------
DROP TABLE IF EXISTS `td_user`;
CREATE TABLE `td_user` (
  `uid` bigint(20) NOT NULL AUTO_INCREMENT,
  `userName` varchar(48) DEFAULT NULL,
  `password` varchar(48) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `gender` bigint(20) DEFAULT NULL,
  `phone` varchar(33) DEFAULT NULL,
  `level` bigint(20) DEFAULT NULL,
  `regdate` date DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `vip` bigint(20) DEFAULT NULL,
  `lastip` bigint(20) DEFAULT NULL,
  `address` varchar(33) DEFAULT NULL,
  `wish` longtext,
  `photo` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=gbk;

-- ----------------------------
--  Records of `td_user`
-- ----------------------------
BEGIN;
INSERT INTO `td_user` VALUES ('6', '333333', '333333', '333333@qq.com', '0', '13333333333', null, '0000-00-00', '2016-11-16', null, '0', '不知道在哪里', '希望柳柳永远在我身边', 'http://ofld5g7th.bkt.clouddn.com/2016-11-16_582c2d7cb429b.jpg'), ('4', 'sdfsdf', 'sdf', '123456@qq.com', '1', '13333333333', null, '2016-11-09', '2016-11-04', null, '0', '四川', '但愿人长久，千里共婵娟sdf', 'http://ofld5g7th.bkt.clouddn.com/2016-11-16_582bbbe208852.jpg'), ('7', '12345', '12345', '12345@qq.com', '1', '15228926211', null, '0000-00-00', '2016-11-02', null, '0', '四川　达州', '１２３４５', 'http://ogrv04tc4.bkt.clouddn.com/2016-11-17_582d6bd32d690.jpg'), ('8', '55555', '55555', '55555@qq.com', null, null, null, '0000-00-00', null, null, '18325', null, null, 'http://ogrv04tc4.bkt.clouddn.com/2016-11-17_582d48713a980.jpg'), ('19', 'dddddd', 'dddddd', 'dddddd@qq.com', null, null, null, '0000-00-00', null, null, '0', null, null, 'http://ogrv04tc4.bkt.clouddn.com/2016-11-18_582eabaf8fcc8.jpg'), ('20', '123456789', '123456789', '123456789@qq.com', null, null, null, '0000-00-00', null, null, '222209', null, null, 'http://ogrv04tc4.bkt.clouddn.com/2016-11-17_582d48713a980.jpg'), ('21', '121212', '121212', '1212@qq.com', '0', '', null, '0000-00-00', '0000-00-00', null, '0', '', '', 'http://ogrv04tc4.bkt.clouddn.com/2016-11-27_583a3404bc131.jpg'), ('22', 'admin', 'goodmw', '1711231134@qq.com', '0', '', null, '0000-00-00', '0000-00-00', null, '0', '', '', 'http://ogrv04tc4.bkt.clouddn.com/2017-01-23_58859b01d015e.jpg'), ('23', '123456', '123456', '1234566@qq.com', '0', '13555559895', null, '0000-00-00', '0000-00-00', null, '0', '', '', 'http://ogrv04tc4.bkt.clouddn.com/2016-11-17_582d48713a980.jpg'), ('24', '12345678', 'wc19941220wc', '1280189982@qq.com', '0', '', null, '0000-00-00', '0000-00-00', null, '0', '', '', 'http://ogrv04tc4.bkt.clouddn.com/2017-02-08_589ad2aea7578.jpg'), ('25', '不具名浪漫', '666666', '666666@qq.com', null, null, null, '0000-00-00', null, null, '11383', null, null, 'http://ogrv04tc4.bkt.clouddn.com/2016-11-17_582d48713a980.jpg');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
